UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'roagGOpX4Gn2Fy0LzLknh+nD0RdiV1/lzmoKvi0vhvM='
WHERE
key_id = '8a01413de8c65895c1f00cf0ae79a6a43ffdf310ec47392af069b2449edc3873'
AND (
token = 'roagGOpX4Gn2Fy0LzLknh+nD0RdiV1/lzmoKvi0vhvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)