UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dCY6HtbKHkJWnmDYvSW/za2WojT72FrPgxrHMq4A2Ro='
WHERE
key_id = '2bf33c41d0e8646dc0fafb72bf4dfc43f714938f3cb7a667e881fef727caab31'
AND (
token = 'dCY6HtbKHkJWnmDYvSW/za2WojT72FrPgxrHMq4A2Ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)