UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKSQXWvWVrb9GS+rZpo67m97vb/m22nozb7MR8QoVqo='
WHERE
key_id = 'a81ee771b43f7d5164c18c520e7ef4926a776105c89963c1737a9e1530bff8ec'
AND (
token = 'ZKSQXWvWVrb9GS+rZpo67m97vb/m22nozb7MR8QoVqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)