UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9dP938cZa1waSiphjjMGtGCwpsJnVR6Qbxwc76dtEcM='
WHERE
key_id = 'e01bcca7f8a23b211cead94218bb43941cb57ed85335ed7d7bcb48aadb7b26d6'
AND (
token = '9dP938cZa1waSiphjjMGtGCwpsJnVR6Qbxwc76dtEcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)