UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XvjI6NkYVvAfeezEdMKt2RzDhGO6OzpWadSnyECTHr0='
WHERE
key_id = '924c60dc704d97e8738ad360086ae8705f07f5111e23e96e7a31fcfb14353a7f'
AND (
token = 'XvjI6NkYVvAfeezEdMKt2RzDhGO6OzpWadSnyECTHr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)