UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8/rGAPHGjEFzA8CX3kFiFGF9d5tEvYhjIYzT0q2/r68='
WHERE
key_id = '0ccb0f53697334c69e371e08f10b45139ab476439d38d4b99f3f933468fb6cb0'
AND (
token = '8/rGAPHGjEFzA8CX3kFiFGF9d5tEvYhjIYzT0q2/r68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)