UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yWcld1EE7cRGhfY+8OQoY6oydbmI+7c9bH3GJGUXadc='
WHERE
key_id = '7d8e361d2070f61c2c25d93a73524cf07c2f6dd421f3da7cd3c44b8926ffe361'
AND (
token = 'yWcld1EE7cRGhfY+8OQoY6oydbmI+7c9bH3GJGUXadc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)