UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M5bUajG6Z260ougwJmhL/RJmoWzhNK9/f1rvpduVwj0='
WHERE
key_id = 'fffd23d8238eb05eba5950511e19270c20dd3b9e27d045bb79dec6b942a0c8c2'
AND (
token = 'M5bUajG6Z260ougwJmhL/RJmoWzhNK9/f1rvpduVwj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)