UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2UBASUtGw8GrQ2+gHTfxDjkOtpnxDkoErDVjlc7Qwr0='
WHERE
key_id = 'f0a09fcd0f93eb6c17aae43e5737b3d140400a2a744f838028f41b238b48596d'
AND (
token = '2UBASUtGw8GrQ2+gHTfxDjkOtpnxDkoErDVjlc7Qwr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)