UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0oJDQbs01Yek93fpDKc631AGWEmUsiJquUZIgfI4bnA='
WHERE
key_id = '4c423eeffb6176b91ec43b52c7102bc0b6c635677439036c7d6de9b6bcad755f'
AND (
token = '0oJDQbs01Yek93fpDKc631AGWEmUsiJquUZIgfI4bnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)