UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kq8l0ko+LwQJSGrmbf4XNzkBfr95NstQ2V13gA8ckqM='
WHERE
key_id = '7d1222c98840e682311e0753a37ba3ee64a7a002486210c5296ef7100273829d'
AND (
token = 'kq8l0ko+LwQJSGrmbf4XNzkBfr95NstQ2V13gA8ckqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)