UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'REv+cc69nt+4glHhsf3T3g6O8WTor7nkKursR1kdUUo='
WHERE
key_id = '8ed1b4e4d13d34b10f8a3fc62cb2b01c8448d60ca4eac571a7a08f05d5623c17'
AND (
token = 'REv+cc69nt+4glHhsf3T3g6O8WTor7nkKursR1kdUUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)