UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bWZJyKxQmuHUVHyY0HeVltsudbgTV7IkQnPk2AL7nc8='
WHERE
key_id = '581a57e9dc2d64d8f1d85233a3198e357ca98c93a55a58f0be23df12959f5f0b'
AND (
token = 'bWZJyKxQmuHUVHyY0HeVltsudbgTV7IkQnPk2AL7nc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)