UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ZkshBOiJhhera1+asS4NdDx9joxVNxSVzHJ+WY+ftk='
WHERE
key_id = '4207ad0028bc6944477f1178e58ab49f895d358d6921796477c94d672cb0844b'
AND (
token = '1ZkshBOiJhhera1+asS4NdDx9joxVNxSVzHJ+WY+ftk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)