UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oAH9rbD5kyXRkGdEQ/6CvhvCb5DJw743tzR9AYWqcYw='
WHERE
key_id = '47afd4bf17ea7bc1e7ebe278b39caac652f5f00769f17233ed28ee1e3b932a7b'
AND (
token = 'oAH9rbD5kyXRkGdEQ/6CvhvCb5DJw743tzR9AYWqcYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)