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