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