UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pSgO05TRp947sHvE6Wq+IhD1w07xln+GhAZz7f9OqqU='
WHERE
key_id = 'f4492853964d6160520e150df24f2d9b79f4c11bd3bdb0b40c9753d9cf474824'
AND (
token = 'pSgO05TRp947sHvE6Wq+IhD1w07xln+GhAZz7f9OqqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)