UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tx2y+XhY0PwAz9bcGvlOapa83q2u00b2P3UbIDlI/dM='
WHERE
key_id = 'eb8d12408c9a9ae9f22143007ae10af71960cdf54889ac0beb6d222ab212c12e'
AND (
token = 'tx2y+XhY0PwAz9bcGvlOapa83q2u00b2P3UbIDlI/dM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)