UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IgevwUwjGaSLHkE5dxVcuVc/kyW/yp8fk8AFe4hTv6o='
WHERE
key_id = '782d4480b1f6edcadda35627b455c8816ca65801078b7cbc0a3548f1ac624fb1'
AND (
token = 'IgevwUwjGaSLHkE5dxVcuVc/kyW/yp8fk8AFe4hTv6o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)