UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hKSbvm6yKiL6I045KK4LW/T2OKNhfvvQfJl2w/49VU='
WHERE
key_id = '62538dbc521d46b041d1702dfaae43fff034dc397f5debe110be418652e80d47'
AND (
token = '6hKSbvm6yKiL6I045KK4LW/T2OKNhfvvQfJl2w/49VU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)