UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BvCZ0y6TsVXCTLi6xlH/qDFKWrdKNSuVkcrJqg3cHfo='
WHERE
key_id = '03b9c0d615bab8f748c1e780139fbf99c1cb413dc21fc3127c98128f35dfa103'
AND (
token = 'BvCZ0y6TsVXCTLi6xlH/qDFKWrdKNSuVkcrJqg3cHfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)