UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1PsoHchoKkn/wncGNKSKteg0dkcPU+y14GkHrHvR730='
WHERE
key_id = '1779334c557ac490ea922679883aa3e6cda30cbe2ab1d6f250d7b387eb861ae6'
AND (
token = '1PsoHchoKkn/wncGNKSKteg0dkcPU+y14GkHrHvR730='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)