UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xzr1t9FOOh9a0vMu1iS591dC5YV4PHdZC8d3WnvPQKM='
WHERE
key_id = 'df36815689605a6f55f9d903c761cd17352de669da5dde765dcf7864b1fb0575'
AND (
token = 'Xzr1t9FOOh9a0vMu1iS591dC5YV4PHdZC8d3WnvPQKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)