UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZSE7Ke+rUk1+vG3ZjT79X0Q/gQBbI8uVSTX7KBs+pg='
WHERE
key_id = 'fb271bfec026c98e4fd42a25fb26bfa71969d9373971f320f73d400e8e606b19'
AND (
token = 'XZSE7Ke+rUk1+vG3ZjT79X0Q/gQBbI8uVSTX7KBs+pg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)