UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x4M5hhaqbQluqhzTQ70uWBvOPvnTY1dgsqO6Pg70HHA='
WHERE
key_id = '380a0fb04a22ce17534cd8093ca1cb94ae88908900ca17c59ac8dc3ef0828cfc'
AND (
token = 'x4M5hhaqbQluqhzTQ70uWBvOPvnTY1dgsqO6Pg70HHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)